# coding=utf-8
# 全世界最帅的帅哥


# subject_info_query = db.text("""
#             SELECT *
#             FROM subject_info a
#             JOIN subject_mapping b ON a.id = b.subject_id
#             WHERE a.id = :subject_id
#               AND b.category_id = :category_id
#               AND b.label_id = :label_id
#               AND a.is_delete = 0
#               AND b.is_delete = 0
#         """)
#
# subject_info = db.session.execute(subject_info_query, {
#     'subject_id': subject_id,  # 替换为实际的subject_id值
#     'category_id': category_id,  # 替换为实际的category_id值
#     'label_id': label_id  # 替换为实际的label_id值
# }).fetchall()
